﻿IF EXISTS (SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_NAME = 'OTMaterialCotizacionDelete')
	BEGIN
		DROP  Procedure  OTMaterialCotizacionDelete
	END
GO

CREATE PROCEDURE [dbo].[OTMaterialCotizacionDelete] 	
	(	
		@Id						AS INT
	)	
AS
BEGIN	
	SET NOCOUNT ON
	
	DELETE FROM Lit_OTMaterialCotizado 
	WHERE Id = @Id
	
	SET NOCOUNT OFF
END 
GO